/*
 Navicat MySQL Data Transfer

 Source Server         : locahost
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44)
 Source Host           : localhost:3306
 Source Schema         : wjjd_cn

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44)
 File Encoding         : 65001

 Date: 31/07/2024 17:51:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cn_ad
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_ad`;
CREATE TABLE `wjjd_ad` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL DEFAULT '' COMMENT '标题',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态 1启用 2禁用',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `position_id` int(10) unsigned NOT NULL COMMENT '推广位置',
  `image` varchar(500) NOT NULL COMMENT '图片',
  `is_delete` tinyint(4) NOT NULL DEFAULT '1' COMMENT '删除状态',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接',
  `desc` varchar(500) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `fk_ad_position1_idx` (`position_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COMMENT='推广';

-- ----------------------------
-- Records of cn_ad
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (1, '关于我们', 1, '2024-07-31 14:33:20', '2024-07-31 14:33:20', 2, 'upload/wjjd_cn/20240731/20240731143318220.jpg', 1, 100, '', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (2, '产品中心', 1, '2024-07-31 14:34:01', '2024-07-31 14:34:01', 3, 'upload/wjjd_cn/20240731/20240731143359724.jpg', 1, 100, '', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (3, '客户案例', 1, '2024-07-31 14:34:16', '2024-07-31 14:34:16', 4, 'upload/wjjd_cn/20240731/20240731143414778.jpg', 1, 100, '', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (4, '新闻资讯', 1, '2024-07-31 14:34:29', '2024-07-31 14:34:29', 6, 'upload/wjjd_cn/20240731/20240731143428481.jpg', 1, 100, '', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (5, '联系我们', 1, '2024-07-31 14:34:58', '2024-07-31 14:34:58', 7, 'upload/wjjd_cn/20240731/20240731143456450.jpg', 1, 100, '', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (6, '首页1', 1, '2024-07-31 15:58:44', '2024-07-31 15:58:44', 1, 'upload/wjjd_cn/20240731/20240731155842182.png', 1, 100, '', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (7, '首页2', 1, '2024-07-31 15:58:53', '2024-07-31 15:58:53', 1, 'upload/wjjd_cn/20240731/20240731155852977.png', 1, 100, '', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (8, '首页3', 1, '2024-07-31 15:59:22', '2024-07-31 15:59:22', 1, 'upload/wjjd_cn/20240731/20240731155921565.png', 1, 100, '', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (9, '公司名称', 1, '2024-07-31 16:28:11', '2024-07-31 16:28:11', 8, 'upload/wjjd_cn/20240731/20240731162809757.jpg', 1, 100, '', '首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介首页公司简介');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (10, '联系我们', 1, '2024-07-31 17:03:56', '2024-07-31 17:03:56', 9, 'upload/wjjd_cn/20240731/20240731170355915.png', 1, 100, '', '五金期待您的来电！');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (11, '百度', 1, '2024-07-31 17:24:40', '2024-07-31 17:24:40', 10, '', 1, 100, 'https://www.baidu.com', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (12, '网易', 1, '2024-07-31 17:25:10', '2024-07-31 17:25:10', 10, '', 1, 100, 'https://www.163.com', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (13, '腾讯', 1, '2024-07-31 17:25:30', '2024-07-31 17:25:30', 10, '', 1, 100, 'https://www.qq.com', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (14, '五金服务热线', 1, '2024-07-31 17:27:28', '2024-07-31 17:27:28', 11, 'upload/wjjd_cn/20240731/20240731172726167.png', 1, 100, '', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (15, '10标题热门关键词', 1, '2024-07-31 17:37:47', '2024-07-31 17:42:58', 12, '', 1, 100, '/search?keywords=标题10&uri=product', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (16, '12标题热门关键词', 1, '2024-07-31 17:38:07', '2024-07-31 17:43:01', 12, '', 1, 100, '/search?keywords=标题12&uri=product', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (17, '13标题热门关键词', 1, '2024-07-31 17:38:20', '2024-07-31 17:43:04', 12, '', 1, 100, '/search?keywords=标题13&uri=product', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (18, '14标题热门关键词', 1, '2024-07-31 17:40:45', '2024-07-31 17:43:07', 12, '', 1, 100, '/search?keywords=标题14&uri=product', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (19, '15标题热门关键词', 1, '2024-07-31 17:40:56', '2024-07-31 17:43:10', 12, '', 1, 100, '/search?keywords=标题15&uri=product', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (20, '标题16热门关键词', 1, '2024-07-31 17:41:10', '2024-07-31 17:43:13', 12, '', 1, 100, '/search?keywords=标题16&uri=product', '');
INSERT INTO `wjjd_ad` (`id`, `title`, `status`, `created_at`, `updated_at`, `position_id`, `image`, `is_delete`, `sort`, `url`, `desc`) VALUES (21, '标题17热门关键词', 1, '2024-07-31 17:41:23', '2024-07-31 17:43:16', 12, '', 1, 100, '/search?keywords=标题17&uri=product', '');
COMMIT;

-- ----------------------------
-- Table structure for cn_ad_position
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_ad_position`;
CREATE TABLE `wjjd_ad_position` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1启用 2禁用',
  `is_delete` tinyint(4) NOT NULL DEFAULT '1' COMMENT '删除状态',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='推广位置';

-- ----------------------------
-- Records of cn_ad_position
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (1, '首页', 1, 1, '2024-07-31 14:32:04', '2024-07-31 14:32:04');
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (2, '关于我们', 1, 1, '2024-07-31 14:32:10', '2024-07-31 14:32:10');
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (3, '产品中心', 1, 1, '2024-07-31 14:32:20', '2024-07-31 14:32:20');
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (4, '客户案例', 1, 1, '2024-07-31 14:32:28', '2024-07-31 14:32:28');
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (5, '合作伙伴', 1, 1, '2024-07-31 14:32:36', '2024-07-31 14:32:36');
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (6, '新闻资讯', 1, 1, '2024-07-31 14:32:43', '2024-07-31 14:32:43');
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (7, '联系我们', 1, 1, '2024-07-31 14:32:49', '2024-07-31 14:32:49');
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (8, '首页公司简介', 1, 1, '2024-07-31 16:27:25', '2024-07-31 16:27:25');
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (9, '内页联系我们', 1, 1, '2024-07-31 17:03:21', '2024-07-31 17:03:21');
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (10, '友情链接', 1, 1, '2024-07-31 17:23:49', '2024-07-31 17:23:49');
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (11, '头部联系电话', 1, 1, '2024-07-31 17:27:00', '2024-07-31 17:27:00');
INSERT INTO `wjjd_ad_position` (`id`, `name`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (12, '热门关键词', 1, 1, '2024-07-31 17:37:16', '2024-07-31 17:39:19');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_about
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_about`;
CREATE TABLE `wjjd_article_about` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `meta_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo标题',
  `meta_description` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `meta_keyword` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo关键字',
  `status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1启用 2禁用',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `image` varchar(255) NOT NULL DEFAULT '' COMMENT '图片',
  `hit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问次数',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  PRIMARY KEY (`id`),
  KEY `key_category_id` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='关于我们';

-- ----------------------------
-- Records of cn_article_about
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_about` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (7, 1, '公司简介', '', '', '', 1, 100, '', 100, '2024-07-31 12:25:20', '2024-07-31 12:25:47', 1);
INSERT INTO `wjjd_article_about` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (8, 2, '企业架构', '', '', '', 1, 100, '', 100, '2024-07-31 13:30:26', '2024-07-31 13:31:05', 1);
COMMIT;

-- ----------------------------
-- Table structure for cn_article_about_flag
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_about_flag`;
CREATE TABLE `wjjd_article_about_flag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `flag_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'flag ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='关于我们';

-- ----------------------------
-- Records of cn_article_about_flag
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_about_image
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_about_image`;
CREATE TABLE `wjjd_article_about_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `image` varchar(200) NOT NULL DEFAULT '' COMMENT '图片',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='关于我们';

-- ----------------------------
-- Records of cn_article_about_image
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_about_relation_attribute
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_about_relation_attribute`;
CREATE TABLE `wjjd_article_about_relation_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid_attribute_id_attribute_value_id` (`aid`,`attribute_id`,`attribute_value_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='关于我们';

-- ----------------------------
-- Records of cn_article_about_relation_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_about_text
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_about_text`;
CREATE TABLE `wjjd_article_about_text` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` text COMMENT '字段值',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='关于我们';

-- ----------------------------
-- Records of cn_article_about_text
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_about_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, 10, '<p style=\"text-indent:2em;\">\n	这里是一段公司简介<span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span>\n</p>\n<p style=\"text-indent:2em;\">\n	<span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><span>这里是一段公司简介</span><br />\n</span>\n</p>', 1, '2024-07-31 12:25:20', '2024-07-31 12:25:47');
INSERT INTO `wjjd_article_about_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 2, 10, '<p style=\"text-indent:2em;\">\n	企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构\n</p>\n<p style=\"text-indent:2em;\">\n	企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构\n</p>', 2, '2024-07-31 13:30:26', '2024-07-31 13:31:05');
INSERT INTO `wjjd_article_about_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (3, 2, 10, '<p style=\"text-indent:2em;\">\n	企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构\n</p>\n<p style=\"text-indent:2em;\">\n	企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构企业架构\n</p>', 1, '2024-07-31 13:30:26', '2024-07-31 13:31:05');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_about_varchar
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_about_varchar`;
CREATE TABLE `wjjd_article_about_varchar` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` varchar(255) NOT NULL DEFAULT '' COMMENT '字段值',
  `is_delete` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='关于我们';

-- ----------------------------
-- Records of cn_article_about_varchar
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_case
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_case`;
CREATE TABLE `wjjd_article_case` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `meta_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo标题',
  `meta_description` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `meta_keyword` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo关键字',
  `status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1启用 2禁用',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `image` varchar(255) NOT NULL DEFAULT '' COMMENT '图片',
  `hit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问次数',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  PRIMARY KEY (`id`),
  KEY `key_category_id` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='客户案例';

-- ----------------------------
-- Records of cn_article_case
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_case` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (13, 1, '客户案例1', '', '', '', 1, 100, 'upload/wjjd_cn/20240731/20240731154116693.png', 100, '2024-07-31 15:41:05', '2024-07-31 15:41:49', 1);
INSERT INTO `wjjd_article_case` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (13, 2, '客户案例2', '', '', '', 1, 101, 'upload/wjjd_cn/20240731/20240731154125778.png', 100, '2024-07-31 15:41:19', '2024-07-31 15:41:40', 1);
INSERT INTO `wjjd_article_case` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (13, 3, '客户案例3', '', '', '', 1, 102, 'upload/wjjd_cn/20240731/20240731162546227.png', 100, '2024-07-31 16:25:33', '2024-07-31 16:25:51', 1);
INSERT INTO `wjjd_article_case` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (13, 4, '客户案例4', '', '', '', 1, 103, 'upload/wjjd_cn/20240731/20240731162604777.png', 100, '2024-07-31 16:25:53', '2024-07-31 16:26:05', 1);
INSERT INTO `wjjd_article_case` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (13, 5, '客户案例5', '', '', '', 1, 104, 'upload/wjjd_cn/20240731/20240731162623613.png', 100, '2024-07-31 16:26:07', '2024-07-31 16:26:24', 1);
INSERT INTO `wjjd_article_case` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (13, 6, '客户案例6', '', '', '', 1, 105, 'upload/wjjd_cn/20240731/20240731162637278.png', 100, '2024-07-31 16:26:26', '2024-07-31 16:26:38', 1);
INSERT INTO `wjjd_article_case` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (13, 7, '客户案例7', '', '', '', 1, 106, 'upload/wjjd_cn/20240731/20240731162648951.png', 100, '2024-07-31 16:26:40', '2024-07-31 16:26:50', 1);
COMMIT;

-- ----------------------------
-- Table structure for cn_article_case_flag
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_case_flag`;
CREATE TABLE `wjjd_article_case_flag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `flag_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'flag ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='客户案例';

-- ----------------------------
-- Records of cn_article_case_flag
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_case_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, 1, 1, '2024-07-31 16:26:57', '2024-07-31 16:26:57');
INSERT INTO `wjjd_article_case_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 2, 1, 1, '2024-07-31 16:26:57', '2024-07-31 16:26:57');
INSERT INTO `wjjd_article_case_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (3, 3, 1, 1, '2024-07-31 16:26:57', '2024-07-31 16:26:57');
INSERT INTO `wjjd_article_case_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (4, 4, 1, 1, '2024-07-31 16:26:57', '2024-07-31 16:26:57');
INSERT INTO `wjjd_article_case_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (5, 5, 1, 1, '2024-07-31 16:26:57', '2024-07-31 16:26:57');
INSERT INTO `wjjd_article_case_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (6, 6, 1, 1, '2024-07-31 16:26:57', '2024-07-31 16:26:57');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_case_image
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_case_image`;
CREATE TABLE `wjjd_article_case_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `image` varchar(200) NOT NULL DEFAULT '' COMMENT '图片',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户案例';

-- ----------------------------
-- Records of cn_article_case_image
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_case_relation_attribute
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_case_relation_attribute`;
CREATE TABLE `wjjd_article_case_relation_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid_attribute_id_attribute_value_id` (`aid`,`attribute_id`,`attribute_value_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户案例';

-- ----------------------------
-- Records of cn_article_case_relation_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_case_text
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_case_text`;
CREATE TABLE `wjjd_article_case_text` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` text COMMENT '字段值',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='客户案例';

-- ----------------------------
-- Records of cn_article_case_text
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_case_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, 30, '', 2, '2024-07-31 15:41:05', '2024-07-31 15:41:49');
INSERT INTO `wjjd_article_case_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 2, 30, '客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1', 2, '2024-07-31 15:41:19', '2024-07-31 15:41:40');
INSERT INTO `wjjd_article_case_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (3, 2, 30, '客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2客户案例2', 1, '2024-07-31 15:41:19', '2024-07-31 15:41:40');
INSERT INTO `wjjd_article_case_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (4, 1, 30, '客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1客户案例1', 1, '2024-07-31 15:41:05', '2024-07-31 15:41:49');
INSERT INTO `wjjd_article_case_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (5, 3, 30, '客户案例3客户案例3客户案例3客户案例3客户案例3', 1, '2024-07-31 16:25:33', '2024-07-31 16:25:51');
INSERT INTO `wjjd_article_case_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (6, 4, 30, '客户案例4客户案例4客户案例4客户案例4客户案例4客户案例4客户案例4客户案例4', 1, '2024-07-31 16:25:53', '2024-07-31 16:26:05');
INSERT INTO `wjjd_article_case_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (7, 5, 30, '客户案例5客户案例5客户案例5客户案例5客户案例5客户案例5', 1, '2024-07-31 16:26:07', '2024-07-31 16:26:24');
INSERT INTO `wjjd_article_case_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (8, 6, 30, '客户案例6客户案例6客户案例6客户案例6客户案例6', 1, '2024-07-31 16:26:26', '2024-07-31 16:26:38');
INSERT INTO `wjjd_article_case_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (9, 7, 30, '', 1, '2024-07-31 16:26:40', '2024-07-31 16:26:50');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_case_varchar
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_case_varchar`;
CREATE TABLE `wjjd_article_case_varchar` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` varchar(255) NOT NULL DEFAULT '' COMMENT '字段值',
  `is_delete` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户案例';

-- ----------------------------
-- Records of cn_article_case_varchar
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_contact
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_contact`;
CREATE TABLE `wjjd_article_contact` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `meta_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo标题',
  `meta_description` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `meta_keyword` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo关键字',
  `status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1启用 2禁用',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `image` varchar(255) NOT NULL DEFAULT '' COMMENT '图片',
  `hit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问次数',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  PRIMARY KEY (`id`),
  KEY `key_category_id` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='联系我们';

-- ----------------------------
-- Records of cn_article_contact
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_contact` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (14, 1, '联系我们', '', '', '', 1, 100, '', 100, '2024-07-31 15:52:58', '2024-07-31 15:53:50', 1);
COMMIT;

-- ----------------------------
-- Table structure for cn_article_contact_flag
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_contact_flag`;
CREATE TABLE `wjjd_article_contact_flag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `flag_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'flag ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='联系我们';

-- ----------------------------
-- Records of cn_article_contact_flag
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_contact_image
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_contact_image`;
CREATE TABLE `wjjd_article_contact_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `image` varchar(200) NOT NULL DEFAULT '' COMMENT '图片',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='联系我们';

-- ----------------------------
-- Records of cn_article_contact_image
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_contact_relation_attribute
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_contact_relation_attribute`;
CREATE TABLE `wjjd_article_contact_relation_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid_attribute_id_attribute_value_id` (`aid`,`attribute_id`,`attribute_value_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='联系我们';

-- ----------------------------
-- Records of cn_article_contact_relation_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_contact_text
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_contact_text`;
CREATE TABLE `wjjd_article_contact_text` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` text COMMENT '字段值',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='联系我们';

-- ----------------------------
-- Records of cn_article_contact_text
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_contact_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, 60, '联系我们联系我们联系我们联系我们联系我们联系我们联系我们', 2, '2024-07-31 15:52:58', '2024-07-31 15:53:50');
INSERT INTO `wjjd_article_contact_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 1, 60, '<p>\n	联系地址：测试联系地址\n</p>\n<p>\n	联系电话：测试联系电话 xxx\n</p>', 1, '2024-07-31 15:52:58', '2024-07-31 15:53:50');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_contact_varchar
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_contact_varchar`;
CREATE TABLE `wjjd_article_contact_varchar` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` varchar(255) NOT NULL DEFAULT '' COMMENT '字段值',
  `is_delete` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='联系我们';

-- ----------------------------
-- Records of cn_article_contact_varchar
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_news
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_news`;
CREATE TABLE `wjjd_article_news` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `meta_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo标题',
  `meta_description` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `meta_keyword` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo关键字',
  `status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1启用 2禁用',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `image` varchar(255) NOT NULL DEFAULT '' COMMENT '图片',
  `hit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问次数',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  PRIMARY KEY (`id`),
  KEY `key_category_id` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COMMENT='新闻资讯';

-- ----------------------------
-- Records of cn_article_news
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 1, '公司新闻标题1', '', '', '', 1, 100, 'upload/wjjd_cn/20240731/20240731153603274.jpg', 100, '2024-07-31 15:35:36', '2024-07-31 15:38:00', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 2, '公司新闻标题2', '', '', '', 1, 101, 'upload/wjjd_cn/20240731/20240731164929326.jpg', 100, '2024-07-31 16:49:03', '2024-07-31 16:49:30', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 3, '公司新闻标题3', '', '', '', 1, 102, 'upload/wjjd_cn/20240731/20240731164948775.jpg', 100, '2024-07-31 16:49:33', '2024-07-31 16:54:22', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 4, '公司新闻标题4', '', '', '', 1, 103, 'upload/wjjd_cn/20240731/20240731165012352.jpg', 100, '2024-07-31 16:49:57', '2024-07-31 16:50:13', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 5, '公司新闻标题5', '', '', '', 1, 104, 'upload/wjjd_cn/20240731/20240731165030168.jpg', 100, '2024-07-31 16:50:16', '2024-07-31 16:50:31', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 6, '公司新闻标题6', '', '', '', 1, 105, 'upload/wjjd_cn/20240731/20240731165047568.jpg', 100, '2024-07-31 16:50:34', '2024-07-31 16:50:48', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 7, '公司新闻标题7', '', '', '', 1, 106, 'upload/wjjd_cn/20240731/20240731165113969.jpg', 100, '2024-07-31 16:51:03', '2024-07-31 16:51:14', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 8, '公司新闻标题8', '', '', '', 1, 107, 'upload/wjjd_cn/20240731/20240731165129345.jpg', 100, '2024-07-31 16:51:16', '2024-07-31 16:51:30', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 9, '公司新闻标题9', '', '', '', 1, 108, 'upload/wjjd_cn/20240731/20240731165143182.jpg', 100, '2024-07-31 16:51:33', '2024-07-31 16:51:44', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 10, '公司新闻标题10', '', '', '', 1, 109, 'upload/wjjd_cn/20240731/20240731165218725.jpg', 100, '2024-07-31 16:52:05', '2024-07-31 16:52:18', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 11, '公司新闻标题11', '', '', '', 1, 110, 'upload/wjjd_cn/20240731/20240731165237988.jpg', 100, '2024-07-31 16:52:21', '2024-07-31 16:52:38', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 12, '公司新闻标题12', '', '', '', 1, 111, 'upload/wjjd_cn/20240731/20240731165255106.jpg', 100, '2024-07-31 16:52:42', '2024-07-31 16:52:56', 1);
INSERT INTO `wjjd_article_news` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (11, 13, '公司新闻标题13', '', '', '', 1, 112, 'upload/wjjd_cn/20240731/20240731165517848.jpg', 100, '2024-07-31 16:55:08', '2024-07-31 16:55:18', 1);
COMMIT;

-- ----------------------------
-- Table structure for cn_article_news_flag
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_news_flag`;
CREATE TABLE `wjjd_article_news_flag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `flag_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'flag ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COMMENT='新闻资讯';

-- ----------------------------
-- Records of cn_article_news_flag
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, 1, 1, '2024-07-31 16:51:55', '2024-07-31 16:51:55');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 2, 1, 1, '2024-07-31 16:51:55', '2024-07-31 16:51:55');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (3, 3, 1, 1, '2024-07-31 16:51:55', '2024-07-31 16:51:55');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (4, 4, 1, 1, '2024-07-31 16:51:55', '2024-07-31 16:51:55');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (5, 5, 1, 1, '2024-07-31 16:51:55', '2024-07-31 16:51:55');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (6, 6, 1, 1, '2024-07-31 16:51:55', '2024-07-31 16:51:55');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (7, 7, 1, 1, '2024-07-31 16:51:55', '2024-07-31 16:51:55');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (8, 8, 1, 1, '2024-07-31 16:55:00', '2024-07-31 16:55:00');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (9, 9, 1, 1, '2024-07-31 16:55:00', '2024-07-31 16:55:00');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (10, 10, 1, 1, '2024-07-31 16:55:00', '2024-07-31 16:55:00');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (11, 11, 1, 1, '2024-07-31 16:55:00', '2024-07-31 16:55:00');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (12, 12, 1, 1, '2024-07-31 16:55:00', '2024-07-31 16:55:00');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (13, 1, 3, 2, '2024-07-31 17:00:42', '2024-07-31 17:01:17');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (14, 3, 3, 2, '2024-07-31 17:00:42', '2024-07-31 17:01:17');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (15, 5, 3, 2, '2024-07-31 17:00:42', '2024-07-31 17:01:17');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (16, 7, 3, 2, '2024-07-31 17:00:42', '2024-07-31 17:01:17');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (17, 9, 3, 2, '2024-07-31 17:00:42', '2024-07-31 17:01:17');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (18, 1, 2, 1, '2024-07-31 17:01:29', '2024-07-31 17:01:29');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (19, 3, 2, 1, '2024-07-31 17:01:29', '2024-07-31 17:01:29');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (20, 5, 2, 1, '2024-07-31 17:01:29', '2024-07-31 17:01:29');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (21, 7, 2, 1, '2024-07-31 17:01:29', '2024-07-31 17:01:29');
INSERT INTO `wjjd_article_news_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (22, 9, 2, 1, '2024-07-31 17:01:29', '2024-07-31 17:01:29');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_news_image
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_news_image`;
CREATE TABLE `wjjd_article_news_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `image` varchar(200) NOT NULL DEFAULT '' COMMENT '图片',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='新闻资讯';

-- ----------------------------
-- Records of cn_article_news_image
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_news_relation_attribute
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_news_relation_attribute`;
CREATE TABLE `wjjd_article_news_relation_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid_attribute_id_attribute_value_id` (`aid`,`attribute_id`,`attribute_value_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='新闻资讯';

-- ----------------------------
-- Records of cn_article_news_relation_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_news_text
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_news_text`;
CREATE TABLE `wjjd_article_news_text` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` text COMMENT '字段值',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COMMENT='新闻资讯';

-- ----------------------------
-- Records of cn_article_news_text
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, 50, '公司新闻内容1<span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span>', 2, '2024-07-31 15:35:36', '2024-07-31 15:38:00');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 1, 50, '公司新闻内容1<span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span><span>公司新闻内容1</span>', 1, '2024-07-31 15:35:36', '2024-07-31 15:38:00');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (3, 2, 50, '公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2', 1, '2024-07-31 16:49:03', '2024-07-31 16:49:30');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (4, 3, 50, '公司新闻标题3公司新闻标题3公司新闻标题3公司新闻标题3公司新闻标题3公司新闻标题3', 2, '2024-07-31 16:49:33', '2024-07-31 16:54:22');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (5, 4, 50, '公司新闻标题4公司新闻标题4公司新闻标题4公司新闻标题4公司新闻标题4公司新闻标题4公司新闻标题4', 1, '2024-07-31 16:49:57', '2024-07-31 16:50:13');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (6, 5, 50, '公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5', 1, '2024-07-31 16:50:16', '2024-07-31 16:50:31');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (7, 6, 50, '公司新闻标题6公司新闻标题6公司新闻标题6公司新闻标题6公司新闻标题6', 1, '2024-07-31 16:50:34', '2024-07-31 16:50:48');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (8, 7, 50, '公司新闻标题7公司新闻标题7公司新闻标题7公司新闻标题7公司新闻标题7公司新闻标题7公司新闻标题7公司新闻标题7公司新闻标题7公司新闻标题7', 1, '2024-07-31 16:51:03', '2024-07-31 16:51:14');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (9, 8, 50, '公司新闻标题8公司新闻标题8公司新闻标题8公司新闻标题8公司新闻标题8', 1, '2024-07-31 16:51:16', '2024-07-31 16:51:30');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (10, 9, 50, '公司新闻标题9公司新闻标题9公司新闻标题9公司新闻标题9公司新闻标题9公司新闻标题9公司新闻标题9公司新闻标题9', 1, '2024-07-31 16:51:33', '2024-07-31 16:51:44');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (11, 10, 50, '公司新闻标题10公司新闻标题10公司新闻标题10公司新闻标题10公司新闻标题10公司新闻标题10公司新闻标题10', 1, '2024-07-31 16:52:05', '2024-07-31 16:52:18');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (12, 11, 50, '公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11', 2, '2024-07-31 16:52:21', '2024-07-31 16:52:38');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (13, 11, 50, '公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11', 1, '2024-07-31 16:52:21', '2024-07-31 16:52:38');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (14, 12, 50, '公司新闻标题12公司新闻标题12公司新闻标题12公司新闻标题12公司新闻标题12公司新闻标题12', 1, '2024-07-31 16:52:42', '2024-07-31 16:52:56');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (15, 3, 50, '公司新闻标题3公司新闻标题3公司新闻标题3公司新闻标题3公司新闻标题3公司新闻标题3', 1, '2024-07-31 16:49:33', '2024-07-31 16:54:22');
INSERT INTO `wjjd_article_news_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (16, 13, 50, '公司新闻标题13公司新闻标题13', 1, '2024-07-31 16:55:08', '2024-07-31 16:55:18');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_news_varchar
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_news_varchar`;
CREATE TABLE `wjjd_article_news_varchar` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` varchar(255) NOT NULL DEFAULT '' COMMENT '字段值',
  `is_delete` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COMMENT='新闻资讯';

-- ----------------------------
-- Records of cn_article_news_varchar
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, 61, '公司新闻列表描述1', 2, '2024-07-31 15:35:36', '2024-07-31 15:38:00');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 1, 61, '公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1公司新闻列表描述1', 1, '2024-07-31 15:35:36', '2024-07-31 15:38:00');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (3, 2, 61, '公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2公司新闻标题2', 1, '2024-07-31 16:49:03', '2024-07-31 16:49:30');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (4, 3, 61, '', 2, '2024-07-31 16:49:33', '2024-07-31 16:54:22');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (5, 4, 61, '公司新闻标题4公司新闻标题4公司新闻标题4公司新闻标题4公司新闻标题4公司新闻标题4公司新闻标题4', 1, '2024-07-31 16:49:57', '2024-07-31 16:50:13');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (6, 5, 61, '公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5公司新闻标题5', 1, '2024-07-31 16:50:16', '2024-07-31 16:50:31');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (7, 6, 61, '公司新闻标题6公司新闻标题6公司新闻标题6公司新闻标题6公司新闻标题6公司新闻标题6公司新闻标题6公司新闻标题6公司新闻标题6', 1, '2024-07-31 16:50:34', '2024-07-31 16:50:48');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (8, 7, 61, '公司新闻标题7公司新闻标题7公司新闻标题7公司新闻标题7公司新闻标题7公司新闻标题7公司新闻标题7', 1, '2024-07-31 16:51:03', '2024-07-31 16:51:14');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (9, 8, 61, '公司新闻标题8公司新闻标题8公司新闻标题8公司新闻标题8公司新闻标题8公司新闻标题8v', 1, '2024-07-31 16:51:16', '2024-07-31 16:51:30');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (10, 9, 61, '公司新闻标题9公司新闻标题9公司新闻标题9公司新闻标题9', 1, '2024-07-31 16:51:33', '2024-07-31 16:51:44');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (11, 10, 61, '公司新闻标题10公司新闻标题10公司新闻标题10公司新闻标题10公司新闻标题10公司新闻标题10公司新闻标题10公司新闻标题10公司新闻标题10公司新闻标题10', 1, '2024-07-31 16:52:05', '2024-07-31 16:52:18');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (12, 11, 61, '公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11', 2, '2024-07-31 16:52:21', '2024-07-31 16:52:38');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (13, 11, 61, '公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11公司新闻标题11', 1, '2024-07-31 16:52:21', '2024-07-31 16:52:38');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (14, 12, 61, '公司新闻标题12公司新闻标题12公司新闻标题12公司新闻标题12公司新闻标题12', 1, '2024-07-31 16:52:42', '2024-07-31 16:52:56');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (15, 3, 61, '公司新闻标题3公司新闻标题3公司新闻标题3公司新闻标题3公司新闻标题3公司新闻标题3公司新闻标题3', 1, '2024-07-31 16:49:33', '2024-07-31 16:54:22');
INSERT INTO `wjjd_article_news_varchar` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (16, 13, 61, '公司新闻标题13公司新闻标题13公司新闻标题13公司新闻标题13公司新闻标题13公司新闻标题13', 1, '2024-07-31 16:55:08', '2024-07-31 16:55:18');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_partner
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_partner`;
CREATE TABLE `wjjd_article_partner` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `meta_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo标题',
  `meta_description` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `meta_keyword` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo关键字',
  `status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1启用 2禁用',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `image` varchar(255) NOT NULL DEFAULT '' COMMENT '图片',
  `hit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问次数',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  PRIMARY KEY (`id`),
  KEY `key_category_id` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COMMENT='合作伙伴';

-- ----------------------------
-- Records of cn_article_partner
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 1, '合作伙伴1', '', '', '', 1, 100, 'upload/wjjd_cn/20240731/20240731154321902.jpg', 100, '2024-07-31 15:42:44', '2024-07-31 15:43:23', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 2, '合作伙伴2', '', '', '', 1, 101, 'upload/wjjd_cn/20240731/20240731154339972.jpg', 100, '2024-07-31 15:43:26', '2024-07-31 15:43:40', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 3, '合作伙伴3', '', '', '', 1, 102, 'upload/wjjd_cn/20240731/20240731154350578.jpg', 100, '2024-07-31 15:43:42', '2024-07-31 15:43:51', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 4, '合作伙伴4', '', '', '', 1, 103, 'upload/wjjd_cn/20240731/20240731154403597.jpg', 100, '2024-07-31 15:43:55', '2024-07-31 15:44:04', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 5, '合作伙伴5', '', '', '', 1, 104, 'upload/wjjd_cn/20240731/20240731154414568.jpg', 100, '2024-07-31 15:44:07', '2024-07-31 15:44:15', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 6, '合作伙伴6', '', '', '', 1, 105, 'upload/wjjd_cn/20240731/20240731154433572.jpg', 100, '2024-07-31 15:44:18', '2024-07-31 15:44:35', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 7, '合作伙伴7', '', '', '', 1, 106, 'upload/wjjd_cn/20240731/20240731164559578.jpg', 100, '2024-07-31 16:45:49', '2024-07-31 16:46:07', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 8, '合作伙伴8', '', '', '', 1, 107, 'upload/wjjd_cn/20240731/20240731164618860.jpg', 100, '2024-07-31 16:46:09', '2024-07-31 16:46:18', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 9, '合作伙伴9', '', '', '', 1, 108, 'upload/wjjd_cn/20240731/20240731164630261.jpg', 100, '2024-07-31 16:46:21', '2024-07-31 16:46:30', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 10, '合作伙伴10', '', '', '', 1, 109, 'upload/wjjd_cn/20240731/20240731164642274.jpg', 100, '2024-07-31 16:46:33', '2024-07-31 16:46:43', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 11, '合作伙伴11', '', '', '', 1, 110, 'upload/wjjd_cn/20240731/20240731164654815.jpg', 100, '2024-07-31 16:46:45', '2024-07-31 16:46:54', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 12, '合作伙伴12', '', '', '', 1, 111, 'upload/wjjd_cn/20240731/20240731164704826.jpg', 100, '2024-07-31 16:46:56', '2024-07-31 16:47:04', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 13, '合作伙伴13', '', '', '', 1, 112, 'upload/wjjd_cn/20240731/20240731164713340.jpg', 100, '2024-07-31 16:47:06', '2024-07-31 16:47:14', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 14, '合作伙伴14', '', '', '', 1, 113, 'upload/wjjd_cn/20240731/20240731164724506.jpg', 100, '2024-07-31 16:47:16', '2024-07-31 16:47:25', 1);
INSERT INTO `wjjd_article_partner` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (4, 15, '合作伙伴15', '', '', '', 1, 114, 'upload/wjjd_cn/20240731/20240731164737988.jpg', 100, '2024-07-31 16:47:28', '2024-07-31 16:47:38', 1);
COMMIT;

-- ----------------------------
-- Table structure for cn_article_partner_flag
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_partner_flag`;
CREATE TABLE `wjjd_article_partner_flag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `flag_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'flag ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COMMENT='合作伙伴';

-- ----------------------------
-- Records of cn_article_partner_flag
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, 1, 1, '2024-07-31 16:45:38', '2024-07-31 16:45:38');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 2, 1, 1, '2024-07-31 16:45:38', '2024-07-31 16:45:38');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (3, 3, 1, 1, '2024-07-31 16:45:38', '2024-07-31 16:45:38');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (4, 4, 1, 1, '2024-07-31 16:45:38', '2024-07-31 16:45:38');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (5, 5, 1, 1, '2024-07-31 16:45:38', '2024-07-31 16:45:38');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (6, 6, 1, 1, '2024-07-31 16:45:38', '2024-07-31 16:45:38');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (7, 7, 1, 1, '2024-07-31 16:47:49', '2024-07-31 16:47:49');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (8, 8, 1, 1, '2024-07-31 16:47:49', '2024-07-31 16:47:49');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (9, 9, 1, 1, '2024-07-31 16:47:49', '2024-07-31 16:47:49');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (10, 10, 1, 1, '2024-07-31 16:47:49', '2024-07-31 16:47:49');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (11, 11, 1, 1, '2024-07-31 16:47:49', '2024-07-31 16:47:49');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (12, 12, 1, 1, '2024-07-31 16:47:49', '2024-07-31 16:47:49');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (13, 13, 1, 1, '2024-07-31 16:47:49', '2024-07-31 16:47:49');
INSERT INTO `wjjd_article_partner_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (14, 14, 1, 1, '2024-07-31 16:47:49', '2024-07-31 16:47:49');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_partner_image
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_partner_image`;
CREATE TABLE `wjjd_article_partner_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `image` varchar(200) NOT NULL DEFAULT '' COMMENT '图片',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='合作伙伴';

-- ----------------------------
-- Records of cn_article_partner_image
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_partner_relation_attribute
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_partner_relation_attribute`;
CREATE TABLE `wjjd_article_partner_relation_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid_attribute_id_attribute_value_id` (`aid`,`attribute_id`,`attribute_value_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='合作伙伴';

-- ----------------------------
-- Records of cn_article_partner_relation_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_partner_text
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_partner_text`;
CREATE TABLE `wjjd_article_partner_text` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` text COMMENT '字段值',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COMMENT='合作伙伴';

-- ----------------------------
-- Records of cn_article_partner_text
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, 40, '', 1, '2024-07-31 15:42:44', '2024-07-31 15:43:23');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 2, 40, '', 1, '2024-07-31 15:43:26', '2024-07-31 15:43:40');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (3, 3, 40, '', 1, '2024-07-31 15:43:42', '2024-07-31 15:43:51');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (4, 4, 40, '', 1, '2024-07-31 15:43:55', '2024-07-31 15:44:04');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (5, 5, 40, '', 1, '2024-07-31 15:44:07', '2024-07-31 15:44:15');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (6, 6, 40, '', 1, '2024-07-31 15:44:18', '2024-07-31 15:44:35');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (7, 7, 40, '', 2, '2024-07-31 16:45:49', '2024-07-31 16:46:07');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (8, 7, 40, '合作伙伴7合作伙伴7合作伙伴7合作伙伴7合作伙伴7合作伙伴7', 1, '2024-07-31 16:45:49', '2024-07-31 16:46:07');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (9, 8, 40, '合作伙伴8合作伙伴8合作伙伴8合作伙伴8合作伙伴8合作伙伴8合作伙伴8合作伙伴8', 1, '2024-07-31 16:46:09', '2024-07-31 16:46:18');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (10, 9, 40, '合作伙伴9合作伙伴9合作伙伴9合作伙伴9合作伙伴9合作伙伴9合作伙伴9合作伙伴9合作伙伴9', 1, '2024-07-31 16:46:21', '2024-07-31 16:46:30');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (11, 10, 40, '合作伙伴10合作伙伴10合作伙伴10合作伙伴10合作伙伴10合作伙伴10合作伙伴10', 1, '2024-07-31 16:46:33', '2024-07-31 16:46:43');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (12, 11, 40, '合作伙伴11合作伙伴11合作伙伴11合作伙伴11合作伙伴11合作伙伴11合作伙伴11', 1, '2024-07-31 16:46:45', '2024-07-31 16:46:54');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (13, 12, 40, '合作伙伴12合作伙伴12合作伙伴12合作伙伴12合作伙伴12合作伙伴12合作伙伴12', 1, '2024-07-31 16:46:56', '2024-07-31 16:47:04');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (14, 13, 40, '合作伙伴13合作伙伴13合作伙伴13合作伙伴13合作伙伴13合作伙伴13合作伙伴13合作伙伴13合作伙伴13', 1, '2024-07-31 16:47:06', '2024-07-31 16:47:14');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (15, 14, 40, '合作伙伴14合作伙伴14合作伙伴14合作伙伴14合作伙伴14合作伙伴14合作伙伴14合作伙伴14', 1, '2024-07-31 16:47:16', '2024-07-31 16:47:25');
INSERT INTO `wjjd_article_partner_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (16, 15, 40, '合作伙伴15合作伙伴15合作伙伴15合作伙伴15合作伙伴15合作伙伴15', 1, '2024-07-31 16:47:28', '2024-07-31 16:47:38');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_partner_varchar
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_partner_varchar`;
CREATE TABLE `wjjd_article_partner_varchar` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` varchar(255) NOT NULL DEFAULT '' COMMENT '字段值',
  `is_delete` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='合作伙伴';

-- ----------------------------
-- Records of cn_article_partner_varchar
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_product
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_product`;
CREATE TABLE `wjjd_article_product` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `meta_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo标题',
  `meta_description` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `meta_keyword` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo关键字',
  `status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1启用 2禁用',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `image` varchar(255) NOT NULL DEFAULT '' COMMENT '图片',
  `hit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问次数',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  PRIMARY KEY (`id`),
  KEY `key_category_id` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COMMENT='产品中心';

-- ----------------------------
-- Records of cn_article_product
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (9, 1, '标题1', '', '', '', 1, 100, 'upload/wjjd_cn/20240731/20240731150338882.png', 100, '2024-07-31 15:03:24', '2024-07-31 15:03:50', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (9, 2, '标题2', '', '', '', 1, 101, 'upload/wjjd_cn/20240731/20240731150403526.png', 100, '2024-07-31 15:03:54', '2024-07-31 15:04:08', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (10, 3, '标题3', '', '', '', 1, 102, 'upload/wjjd_cn/20240731/20240731150418312.png', 100, '2024-07-31 15:04:10', '2024-07-31 16:21:52', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (9, 4, '标题4', '', '', '', 1, 103, 'upload/wjjd_cn/20240731/20240731150447629.png', 100, '2024-07-31 15:04:29', '2024-07-31 15:04:51', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (9, 5, '标题5', '', '', '', 1, 104, 'upload/wjjd_cn/20240731/20240731150505551.png', 100, '2024-07-31 15:04:53', '2024-07-31 15:05:06', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (9, 6, '标题6', '', '', '', 1, 105, 'upload/wjjd_cn/20240731/20240731150517723.png', 100, '2024-07-31 15:05:09', '2024-07-31 15:05:20', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (9, 7, '标题7', '', '', '', 1, 106, 'upload/wjjd_cn/20240731/20240731150531111.png', 100, '2024-07-31 15:05:23', '2024-07-31 15:05:34', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (9, 8, '标题8', '', '', '', 1, 107, 'upload/wjjd_cn/20240731/20240731150545400.png', 100, '2024-07-31 15:05:36', '2024-07-31 15:05:48', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (10, 9, '标题9', '', '', '', 1, 108, 'upload/wjjd_cn/20240731/20240731150559416.png', 100, '2024-07-31 15:05:51', '2024-07-31 16:22:17', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (10, 10, '标题10', '', '', '', 1, 109, 'upload/wjjd_cn/20240731/20240731150613548.png', 100, '2024-07-31 15:06:05', '2024-07-31 16:21:39', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (10, 11, '标题11', '', '', '', 1, 110, 'upload/wjjd_cn/20240731/20240731150627388.png', 100, '2024-07-31 15:06:20', '2024-07-31 16:21:59', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (9, 12, '标题12', '', '', '', 1, 111, 'upload/wjjd_cn/20240731/20240731150639976.png', 100, '2024-07-31 15:06:33', '2024-07-31 15:06:44', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (9, 13, '标题13', '', '', '', 1, 112, 'upload/wjjd_cn/20240731/20240731150814619.png', 100, '2024-07-31 15:07:59', '2024-07-31 15:08:16', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (10, 14, '标题14', '', '', '', 1, 113, 'upload/wjjd_cn/20240731/20240731150826516.png', 100, '2024-07-31 15:08:18', '2024-07-31 16:22:05', 1);
INSERT INTO `wjjd_article_product` (`category_id`, `id`, `title`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `sort`, `image`, `hit`, `created_at`, `updated_at`, `is_delete`) VALUES (10, 15, '标题15', '', '', '', 1, 114, 'upload/wjjd_cn/20240731/20240731150839905.png', 100, '2024-07-31 15:08:30', '2024-07-31 16:22:11', 1);
COMMIT;

-- ----------------------------
-- Table structure for cn_article_product_flag
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_product_flag`;
CREATE TABLE `wjjd_article_product_flag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `flag_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'flag ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='产品中心';

-- ----------------------------
-- Records of cn_article_product_flag
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_product_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, 1, 1, '2024-07-31 16:04:34', '2024-07-31 16:04:34');
INSERT INTO `wjjd_article_product_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 2, 1, 1, '2024-07-31 16:04:34', '2024-07-31 16:04:34');
INSERT INTO `wjjd_article_product_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (3, 6, 1, 1, '2024-07-31 16:20:12', '2024-07-31 16:20:12');
INSERT INTO `wjjd_article_product_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (4, 7, 1, 1, '2024-07-31 16:20:12', '2024-07-31 16:20:12');
INSERT INTO `wjjd_article_product_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (5, 8, 1, 1, '2024-07-31 16:20:12', '2024-07-31 16:20:12');
INSERT INTO `wjjd_article_product_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (6, 3, 1, 1, '2024-07-31 16:22:28', '2024-07-31 16:22:28');
INSERT INTO `wjjd_article_product_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (7, 9, 1, 1, '2024-07-31 16:22:28', '2024-07-31 16:22:28');
INSERT INTO `wjjd_article_product_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (8, 10, 1, 1, '2024-07-31 16:22:28', '2024-07-31 16:22:28');
INSERT INTO `wjjd_article_product_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (9, 11, 1, 1, '2024-07-31 16:22:28', '2024-07-31 16:22:28');
INSERT INTO `wjjd_article_product_flag` (`id`, `aid`, `flag_id`, `is_delete`, `created_at`, `updated_at`) VALUES (10, 15, 1, 1, '2024-07-31 16:22:28', '2024-07-31 16:22:28');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_product_image
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_product_image`;
CREATE TABLE `wjjd_article_product_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `image` varchar(200) NOT NULL DEFAULT '' COMMENT '图片',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品中心';

-- ----------------------------
-- Records of cn_article_product_image
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_product_relation_attribute
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_product_relation_attribute`;
CREATE TABLE `wjjd_article_product_relation_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `attribute_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性ID',
  `attribute_value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性值ID',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_aid_attribute_id_attribute_value_id` (`aid`,`attribute_id`,`attribute_value_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品中心';

-- ----------------------------
-- Records of cn_article_product_relation_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_article_product_text
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_product_text`;
CREATE TABLE `wjjd_article_product_text` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` text COMMENT '字段值',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COMMENT='产品中心';

-- ----------------------------
-- Records of cn_article_product_text
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, 20, '', 2, '2024-07-31 15:03:24', '2024-07-31 15:03:50');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 1, 20, '标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1标题1', 1, '2024-07-31 15:03:24', '2024-07-31 15:03:50');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (3, 2, 20, '标题2标题2标题2标题2标题2标题2标题2标题2标题2标题2标题2标题2标题2标题2', 1, '2024-07-31 15:03:54', '2024-07-31 15:04:08');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (4, 3, 20, '标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3', 2, '2024-07-31 15:04:10', '2024-07-31 16:21:52');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (5, 4, 20, '标题4标题4标题4标题4标题4标题4标题4标题4标题4标题4标题4标题4标题4标题4标题4', 1, '2024-07-31 15:04:29', '2024-07-31 15:04:51');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (6, 5, 20, '标题5标题5标题5标题5标题5标题5标题5', 1, '2024-07-31 15:04:53', '2024-07-31 15:05:06');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (7, 6, 20, '标题6标题6标题6标题6标题6标题6标题6标题6', 1, '2024-07-31 15:05:09', '2024-07-31 15:05:20');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (8, 7, 20, '标题7标题7标题7标题7标题7标题7标题7标题7标题7标题7', 1, '2024-07-31 15:05:23', '2024-07-31 15:05:34');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (9, 8, 20, '标题8标题8标题8标题8标题8标题8标题8标题8标题8标题8标题8标题8标题8标题8标题8标题8标题8', 1, '2024-07-31 15:05:36', '2024-07-31 15:05:48');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (10, 9, 20, '标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9v', 2, '2024-07-31 15:05:51', '2024-07-31 16:22:17');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (11, 10, 20, '标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10', 2, '2024-07-31 15:06:05', '2024-07-31 16:21:39');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (12, 11, 20, '标题11标题11标题11标题11标题11标题11标题11标题11标题11标题11标题11标题11标题11标题11v', 2, '2024-07-31 15:06:20', '2024-07-31 16:21:59');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (13, 12, 20, '标题12标题12标题12标题12标题12标题12标题12标题12标题12标题12标题12标题12标题12', 1, '2024-07-31 15:06:33', '2024-07-31 15:06:44');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (14, 13, 20, '标题13标题13标题13标题13标题13标题13标题13标题13标题13标题13标题13标题13标题13', 1, '2024-07-31 15:07:59', '2024-07-31 15:08:16');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (15, 14, 20, '标题14标题14标题14标题14标题14标题14标题14标题14标题14标题14标题14标题14标题14', 2, '2024-07-31 15:08:18', '2024-07-31 16:22:05');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (16, 15, 20, '标题15标题15标题15标题15标题15标题15标题15标题15标题15标题15标题15标题15标题15标题15vv', 2, '2024-07-31 15:08:30', '2024-07-31 16:22:11');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (17, 10, 20, '标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10标题10', 1, '2024-07-31 15:06:05', '2024-07-31 16:21:39');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (18, 3, 20, '标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3标题3', 1, '2024-07-31 15:04:10', '2024-07-31 16:21:52');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (19, 11, 20, '标题11标题11标题11标题11标题11标题11标题11标题11标题11标题11标题11标题11标题11标题11v', 1, '2024-07-31 15:06:20', '2024-07-31 16:21:59');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (20, 14, 20, '标题14标题14标题14标题14标题14标题14标题14标题14标题14标题14标题14标题14标题14', 1, '2024-07-31 15:08:18', '2024-07-31 16:22:05');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (21, 15, 20, '标题15标题15标题15标题15标题15标题15标题15标题15标题15标题15标题15标题15标题15标题15vv', 1, '2024-07-31 15:08:30', '2024-07-31 16:22:11');
INSERT INTO `wjjd_article_product_text` (`id`, `aid`, `field_id`, `field_value`, `is_delete`, `created_at`, `updated_at`) VALUES (22, 9, 20, '标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9标题9v', 1, '2024-07-31 15:05:51', '2024-07-31 16:22:17');
COMMIT;

-- ----------------------------
-- Table structure for cn_article_product_varchar
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_article_product_varchar`;
CREATE TABLE `wjjd_article_product_varchar` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `field_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '字段ID',
  `field_value` varchar(255) NOT NULL DEFAULT '' COMMENT '字段值',
  `is_delete` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_field_id` (`field_id`) USING BTREE,
  KEY `key_aid` (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品中心';

-- ----------------------------
-- Records of cn_article_product_varchar
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_attachment
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_attachment`;
CREATE TABLE `wjjd_attachment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL DEFAULT '' COMMENT '标题',
  `url` varchar(200) NOT NULL DEFAULT '' COMMENT '图片地址',
  `url_md5` char(32) NOT NULL DEFAULT '' COMMENT '图片地址md5值',
  `relation_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关联d',
  `relation_type` varchar(10) NOT NULL DEFAULT '' COMMENT '关联类型 ad category article',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '删除标识',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `key_url_md5` (`url_md5`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COMMENT='附件';

-- ----------------------------
-- Records of cn_attachment
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (5, '20240731143318220.jpg', 'upload/wjjd_cn/20240731/20240731143318220.jpg', 'd0f59228ded8d4949f31b95978cf0f8d', 1, 'ad', 1, '2024-07-31 14:33:19', '2024-07-31 14:33:19');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (6, '20240731143359724.jpg', 'upload/wjjd_cn/20240731/20240731143359724.jpg', 'ccf57da91df4038f66a3f459a426aad7', 2, 'ad', 1, '2024-07-31 14:33:59', '2024-07-31 14:34:00');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (7, '20240731143414778.jpg', 'upload/wjjd_cn/20240731/20240731143414778.jpg', 'bd26105489cc446107e0bf9e65de4e2f', 3, 'ad', 1, '2024-07-31 14:34:15', '2024-07-31 14:34:16');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (8, '20240731143428481.jpg', 'upload/wjjd_cn/20240731/20240731143428481.jpg', '5f22a2febeb9352379f8c15b7b387e28', 4, 'ad', 1, '2024-07-31 14:34:28', '2024-07-31 14:34:29');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (9, '20240731143456450.jpg', 'upload/wjjd_cn/20240731/20240731143456450.jpg', 'a7bb52bdd41138f70b206eec9f5895d0', 5, 'ad', 1, '2024-07-31 14:34:57', '2024-07-31 14:34:58');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (10, '20240731150338882.png', 'upload/wjjd_cn/20240731/20240731150338882.png', 'f393c5b4ccdbe4c8922b3e609b0f0289', 1, 'article', 1, '2024-07-31 15:03:38', '2024-07-31 15:03:50');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (11, '20240731150403526.png', 'upload/wjjd_cn/20240731/20240731150403526.png', '880cf893ea06fcd3a4e2784e95a4d169', 2, 'article', 1, '2024-07-31 15:04:04', '2024-07-31 15:04:08');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (12, '20240731150418312.png', 'upload/wjjd_cn/20240731/20240731150418312.png', '382782f43a9022f3d2491cb4b9fef1f7', 3, 'article', 1, '2024-07-31 15:04:19', '2024-07-31 16:21:52');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (13, '20240731150447629.png', 'upload/wjjd_cn/20240731/20240731150447629.png', '59a3a69dbcb2d95d1b80b2d8a9a5f843', 4, 'article', 1, '2024-07-31 15:04:48', '2024-07-31 15:04:51');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (14, '20240731150505551.png', 'upload/wjjd_cn/20240731/20240731150505551.png', '0ec3daaa5d522ab321f6fa56a7fc93af', 5, 'article', 1, '2024-07-31 15:05:06', '2024-07-31 15:05:06');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (15, '20240731150517723.png', 'upload/wjjd_cn/20240731/20240731150517723.png', 'dcf5649facbc3ae4a5158f05a13df9c1', 6, 'article', 1, '2024-07-31 15:05:17', '2024-07-31 15:05:20');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (16, '20240731150531111.png', 'upload/wjjd_cn/20240731/20240731150531111.png', '7472133c225c1293989a729cf7d3111b', 7, 'article', 1, '2024-07-31 15:05:31', '2024-07-31 15:05:34');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (17, '20240731150545400.png', 'upload/wjjd_cn/20240731/20240731150545400.png', 'a0ede290caf158687e5a454b7df418d9', 8, 'article', 1, '2024-07-31 15:05:45', '2024-07-31 15:05:48');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (18, '20240731150559416.png', 'upload/wjjd_cn/20240731/20240731150559416.png', '4c1fe606dfc7f0fd3010f4b5476db28b', 9, 'article', 1, '2024-07-31 15:06:00', '2024-07-31 16:22:17');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (19, '20240731150613548.png', 'upload/wjjd_cn/20240731/20240731150613548.png', '5d66eca5026ecf08a84560e3499276c6', 10, 'article', 1, '2024-07-31 15:06:14', '2024-07-31 16:21:39');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (20, '20240731150627388.png', 'upload/wjjd_cn/20240731/20240731150627388.png', 'ba32449d3c2ca6de5bfb33fdd2196fea', 11, 'article', 1, '2024-07-31 15:06:27', '2024-07-31 16:21:59');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (21, '20240731150639976.png', 'upload/wjjd_cn/20240731/20240731150639976.png', '0ac102a8700f256d1005b66924c66536', 12, 'article', 1, '2024-07-31 15:06:40', '2024-07-31 15:06:44');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (22, '20240731150814619.png', 'upload/wjjd_cn/20240731/20240731150814619.png', '23d423ccbe980e73911c7dd9239f95a9', 13, 'article', 1, '2024-07-31 15:08:15', '2024-07-31 15:08:16');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (23, '20240731150826516.png', 'upload/wjjd_cn/20240731/20240731150826516.png', 'bea587f5dc55fa56db0ddbedac7e1656', 14, 'article', 1, '2024-07-31 15:08:27', '2024-07-31 16:22:05');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (24, '20240731150839905.png', 'upload/wjjd_cn/20240731/20240731150839905.png', '875a805846ca5dd6e07d27eb0840cf4c', 15, 'article', 1, '2024-07-31 15:08:39', '2024-07-31 16:22:11');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (25, '20240731153603274.jpg', 'upload/wjjd_cn/20240731/20240731153603274.jpg', '523c06734f65a4153ce5e06326c03521', 1, 'article', 1, '2024-07-31 15:36:04', '2024-07-31 15:38:00');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (26, '20240731154116693.png', 'upload/wjjd_cn/20240731/20240731154116693.png', 'b08d8c01d4d2f109a6b58081567aa4c8', 1, 'article', 1, '2024-07-31 15:41:16', '2024-07-31 15:41:49');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (27, '20240731154125778.png', 'upload/wjjd_cn/20240731/20240731154125778.png', 'c9c37c49446cec80e489b2a6dddc3d05', 2, 'article', 1, '2024-07-31 15:41:26', '2024-07-31 15:41:40');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (29, '20240731154321902.jpg', 'upload/wjjd_cn/20240731/20240731154321902.jpg', '965c933d5331b7867aefa707d47a0dba', 1, 'article', 1, '2024-07-31 15:43:22', '2024-07-31 15:43:23');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (30, '20240731154339972.jpg', 'upload/wjjd_cn/20240731/20240731154339972.jpg', 'c7ad5974dfd7ee6f31d39e877ab779a4', 2, 'article', 1, '2024-07-31 15:43:39', '2024-07-31 15:43:40');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (31, '20240731154350578.jpg', 'upload/wjjd_cn/20240731/20240731154350578.jpg', '579ec551bfe1830191d001f46b228068', 3, 'article', 1, '2024-07-31 15:43:50', '2024-07-31 15:43:51');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (32, '20240731154403597.jpg', 'upload/wjjd_cn/20240731/20240731154403597.jpg', '11034e51fe4846669c90e14738f95e59', 4, 'article', 1, '2024-07-31 15:44:04', '2024-07-31 15:44:04');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (33, '20240731154414568.jpg', 'upload/wjjd_cn/20240731/20240731154414568.jpg', '0640e90b9e4a25a4a21120470128d840', 5, 'article', 1, '2024-07-31 15:44:15', '2024-07-31 15:44:15');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (35, '20240731154433572.jpg', 'upload/wjjd_cn/20240731/20240731154433572.jpg', '543c6697a367bf71c989e898e58fbfb3', 6, 'article', 1, '2024-07-31 15:44:34', '2024-07-31 15:44:35');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (36, '20240731155842182.png', 'upload/wjjd_cn/20240731/20240731155842182.png', 'd41e6537679b136f3fef6075841f2ff6', 6, 'ad', 1, '2024-07-31 15:58:42', '2024-07-31 15:58:43');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (37, '20240731155852977.png', 'upload/wjjd_cn/20240731/20240731155852977.png', '1b6d6e09d93e2b369d64a401aad172b3', 7, 'ad', 1, '2024-07-31 15:58:52', '2024-07-31 15:58:53');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (38, '20240731155921565.png', 'upload/wjjd_cn/20240731/20240731155921565.png', 'c8faaff091826062e094d9ede2dc8ee2', 8, 'ad', 1, '2024-07-31 15:59:22', '2024-07-31 15:59:22');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (39, '20240731162546227.png', 'upload/wjjd_cn/20240731/20240731162546227.png', 'b18d061c9f18b60adbeb6040a98b495b', 3, 'article', 1, '2024-07-31 16:25:47', '2024-07-31 16:25:51');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (40, '20240731162604777.png', 'upload/wjjd_cn/20240731/20240731162604777.png', 'fc5acf05a9c532f2922f3c48d71a6a0f', 4, 'article', 1, '2024-07-31 16:26:05', '2024-07-31 16:26:05');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (41, '20240731162623613.png', 'upload/wjjd_cn/20240731/20240731162623613.png', 'a4cf5c2eba8190d3d58cc3992163df88', 5, 'article', 1, '2024-07-31 16:26:24', '2024-07-31 16:26:24');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (42, '20240731162637278.png', 'upload/wjjd_cn/20240731/20240731162637278.png', '36be44eb5f1ab3b77e28cde2bd51547e', 6, 'article', 1, '2024-07-31 16:26:38', '2024-07-31 16:26:38');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (43, '20240731162648951.png', 'upload/wjjd_cn/20240731/20240731162648951.png', 'bbc94a3f971654061c24bc9cbac15a79', 7, 'article', 1, '2024-07-31 16:26:49', '2024-07-31 16:26:50');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (44, '20240731162809757.jpg', 'upload/wjjd_cn/20240731/20240731162809757.jpg', '4f26cf229439b884d144db7d6d5570dd', 9, 'ad', 1, '2024-07-31 16:28:10', '2024-07-31 16:28:10');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (45, '20240731164559578.jpg', 'upload/wjjd_cn/20240731/20240731164559578.jpg', 'a63854a69a0573a5964adeeb5ae34368', 7, 'article', 1, '2024-07-31 16:46:00', '2024-07-31 16:46:07');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (46, '20240731164618860.jpg', 'upload/wjjd_cn/20240731/20240731164618860.jpg', '032239c32218ea8cae6ede35a3ef20e8', 8, 'article', 1, '2024-07-31 16:46:18', '2024-07-31 16:46:18');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (47, '20240731164630261.jpg', 'upload/wjjd_cn/20240731/20240731164630261.jpg', '3eee9c9f458a97bb5328061c7695245c', 9, 'article', 1, '2024-07-31 16:46:30', '2024-07-31 16:46:30');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (48, '20240731164642274.jpg', 'upload/wjjd_cn/20240731/20240731164642274.jpg', '69e29cf6b6df05d0d196cfda63d66c68', 10, 'article', 1, '2024-07-31 16:46:42', '2024-07-31 16:46:43');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (49, '20240731164654815.jpg', 'upload/wjjd_cn/20240731/20240731164654815.jpg', '768225eb073370c3f89dc6318fe21d5d', 11, 'article', 1, '2024-07-31 16:46:54', '2024-07-31 16:46:54');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (50, '20240731164704826.jpg', 'upload/wjjd_cn/20240731/20240731164704826.jpg', '14bfdedf49351cf21d9df4a2c1b2212a', 12, 'article', 1, '2024-07-31 16:47:04', '2024-07-31 16:47:04');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (51, '20240731164713340.jpg', 'upload/wjjd_cn/20240731/20240731164713340.jpg', '5b0ef786d9dd7212a9141b274e434a5d', 13, 'article', 1, '2024-07-31 16:47:14', '2024-07-31 16:47:14');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (52, '20240731164724506.jpg', 'upload/wjjd_cn/20240731/20240731164724506.jpg', 'c482388488095364b5b2a4333ddc8d1e', 14, 'article', 1, '2024-07-31 16:47:25', '2024-07-31 16:47:25');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (53, '20240731164737988.jpg', 'upload/wjjd_cn/20240731/20240731164737988.jpg', 'ba083409b2adb310a50e6e7d2ebdcedf', 15, 'article', 1, '2024-07-31 16:47:38', '2024-07-31 16:47:38');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (55, '20240731164929326.jpg', 'upload/wjjd_cn/20240731/20240731164929326.jpg', 'c1772c4cb0b7c3b1c8fbb3a09572fabd', 2, 'article', 1, '2024-07-31 16:49:29', '2024-07-31 16:49:30');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (56, '20240731164948775.jpg', 'upload/wjjd_cn/20240731/20240731164948775.jpg', '05696e973c16cc0cf39cbbd4ee0af19a', 3, 'article', 1, '2024-07-31 16:49:49', '2024-07-31 16:54:22');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (57, '20240731165012352.jpg', 'upload/wjjd_cn/20240731/20240731165012352.jpg', '456e74cac26958022cbb59fa7cea9d65', 4, 'article', 1, '2024-07-31 16:50:13', '2024-07-31 16:50:13');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (58, '20240731165030168.jpg', 'upload/wjjd_cn/20240731/20240731165030168.jpg', '68c125a646edcf6735bcc044bf8ebd86', 5, 'article', 1, '2024-07-31 16:50:31', '2024-07-31 16:50:31');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (59, '20240731165047568.jpg', 'upload/wjjd_cn/20240731/20240731165047568.jpg', '1ac2324bfb69a23a50a4c1d261483402', 6, 'article', 1, '2024-07-31 16:50:48', '2024-07-31 16:50:48');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (60, '20240731165113969.jpg', 'upload/wjjd_cn/20240731/20240731165113969.jpg', '3662d69a42aec48ebe45df5fc9dc1b7c', 7, 'article', 1, '2024-07-31 16:51:13', '2024-07-31 16:51:14');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (61, '20240731165129345.jpg', 'upload/wjjd_cn/20240731/20240731165129345.jpg', 'c710eec8d485a9da56ed6c8f065922d4', 8, 'article', 1, '2024-07-31 16:51:29', '2024-07-31 16:51:30');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (62, '20240731165143182.jpg', 'upload/wjjd_cn/20240731/20240731165143182.jpg', 'df56efe0ecbe39803538475f50e91ae8', 9, 'article', 1, '2024-07-31 16:51:43', '2024-07-31 16:51:44');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (64, '20240731165218725.jpg', 'upload/wjjd_cn/20240731/20240731165218725.jpg', '8697b26370063bbf75036e507c2d8851', 10, 'article', 1, '2024-07-31 16:52:18', '2024-07-31 16:52:18');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (65, '20240731165237988.jpg', 'upload/wjjd_cn/20240731/20240731165237988.jpg', '03cd420dd427fb50de48e4ed268d55b6', 11, 'article', 1, '2024-07-31 16:52:37', '2024-07-31 16:52:38');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (66, '20240731165255106.jpg', 'upload/wjjd_cn/20240731/20240731165255106.jpg', 'ba9d1ccfaa6ad658f45412f83c4e3afb', 12, 'article', 1, '2024-07-31 16:52:56', '2024-07-31 16:52:56');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (67, '20240731165517848.jpg', 'upload/wjjd_cn/20240731/20240731165517848.jpg', 'f10d6c484d68f6ba50ab1744627322a8', 13, 'article', 1, '2024-07-31 16:55:17', '2024-07-31 16:55:18');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (68, '20240731170355915.png', 'upload/wjjd_cn/20240731/20240731170355915.png', 'b1e8a1105659dd968231de517179b480', 10, 'ad', 1, '2024-07-31 17:03:55', '2024-07-31 17:03:56');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (69, '20240731171126403.jpg', 'upload/wjjd_cn/20240731/20240731171126403.jpg', '17f9d54fcca4c0860ba49d36330dbeaf', 0, '', 1, '2024-07-31 17:11:27', '2024-07-31 17:11:27');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (70, '20240731171444736.jpg', 'upload/wjjd_cn/20240731/20240731171444736.jpg', '21ea333bea75dc28c1686b0dc4d8c722', 0, '', 1, '2024-07-31 17:14:44', '2024-07-31 17:14:44');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (71, '20240731171451152.jpg', 'upload/wjjd_cn/20240731/20240731171451152.jpg', 'b9401eb35a8047206633ce6c8e97545d', 0, '', 1, '2024-07-31 17:14:51', '2024-07-31 17:14:51');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (72, '20240731172117318.jpg', 'upload/wjjd_cn/20240731/20240731172117318.jpg', '789f8c29fca18562d3b58367c5ebaa67', 0, '', 1, '2024-07-31 17:21:17', '2024-07-31 17:21:17');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (73, '20240731172130598.jpg', 'upload/wjjd_cn/20240731/20240731172130598.jpg', '51f7a57f0bdf9a20476c300f75388612', 0, '', 1, '2024-07-31 17:21:30', '2024-07-31 17:21:30');
INSERT INTO `wjjd_attachment` (`id`, `title`, `url`, `url_md5`, `relation_id`, `relation_type`, `is_delete`, `created_at`, `updated_at`) VALUES (74, '20240731172726167.png', 'upload/wjjd_cn/20240731/20240731172726167.png', 'da40ff2fc9bd1fea77e292845c3e4ae5', 14, 'ad', 1, '2024-07-31 17:27:26', '2024-07-31 17:27:27');
COMMIT;

-- ----------------------------
-- Table structure for cn_attribute
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_attribute`;
CREATE TABLE `wjjd_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '属性集合名称',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '属性集合状态1启用 2禁用',
  `is_sales` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否是销售属性1是 2不是',
  `attribute_type` tinyint(4) NOT NULL COMMENT '属性类型1普通属性 2属性图片',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '删除标识1未删除 2已删除',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_category_id` (`is_sales`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='属性';

-- ----------------------------
-- Records of cn_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_attribute_value
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_attribute_value`;
CREATE TABLE `wjjd_attribute_value` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '属性值说明',
  `attribute_value` varchar(255) NOT NULL DEFAULT '' COMMENT '属性值',
  `attribute_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性id',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '删除标识1未删除 2已删除',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_attribute_id` (`attribute_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='属性值';

-- ----------------------------
-- Records of cn_attribute_value
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_category
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_category`;
CREATE TABLE `wjjd_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
  `title_en` varchar(255) NOT NULL DEFAULT '' COMMENT '英文名称',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父级',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1启用 2禁用',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `meta_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo标题',
  `meta_keyword` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo关键词',
  `meta_description` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `module_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '模型id',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '删除标识',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '页面类型\n1 单页 2封面 3列表 4跳转',
  `is_redirect_child` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '跳转子分类',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '路由标识',
  `page` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '每页数量',
  `go_url` varchar(255) NOT NULL DEFAULT '' COMMENT '跳转地址',
  `default_tpl` varchar(255) NOT NULL DEFAULT '' COMMENT '封面页模板名称',
  `list_tpl` varchar(255) NOT NULL DEFAULT '' COMMENT '列表页模板名称',
  `view_tpl` varchar(255) NOT NULL DEFAULT '' COMMENT '详细页模板名称',
  `target` tinyint(4) NOT NULL DEFAULT '1' COMMENT '打开方式1当前 2新窗口',
  `image` varchar(255) NOT NULL DEFAULT '' COMMENT '栏目图片',
  `is_relation` tinyint(4) NOT NULL DEFAULT '2' COMMENT '是否开启文档关联 1开启关联 2关闭关联',
  `relation_attribute_count` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '关联属性数量',
  `seo_url` varchar(255) NOT NULL DEFAULT '' COMMENT '自定义url',
  `uri` varchar(255) NOT NULL DEFAULT '' COMMENT '访问uri',
  `introduce_content` varchar(1000) NOT NULL DEFAULT '' COMMENT '栏目介绍',
  `introduce_video_url` varchar(255) NOT NULL DEFAULT '' COMMENT '栏目介绍视频',
  `introduce_image` varchar(255) NOT NULL DEFAULT '',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `note` varchar(1000) NOT NULL DEFAULT '' COMMENT '备注说明',
  `note_image` varchar(255) NOT NULL DEFAULT '' COMMENT '备注图片',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `fk_category_model1_idx` (`module_id`) USING BTREE,
  KEY `key_uri` (`uri`(191)) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COMMENT='分类';

-- ----------------------------
-- Records of cn_category
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (1, '关于我们', 'about us', 0, 1, 100, '', '', '', 1, 1, 1, 2, 'about', 20, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'about us', '/about-us', '', '', '', '2024-07-31 11:49:26', '2024-07-31 11:51:53', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (2, '产品中心', 'product', 0, 1, 100, '', '', '', 2, 1, 3, 1, 'product', 9, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'product', '/product', '', '', '', '2024-07-31 11:50:08', '2024-07-31 15:10:06', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (3, '客户案例', 'case', 0, 1, 100, '', '', '', 3, 1, 3, 1, 'case', 9, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'case', '/case', '', '', '', '2024-07-31 11:50:25', '2024-07-31 15:40:50', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (4, '合作伙伴', 'partner', 0, 1, 100, '', '', '', 4, 1, 3, 1, 'partner', 20, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'partner', '/partner', '', '', '', '2024-07-31 11:50:49', '2024-07-31 15:42:28', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (5, '新闻资讯', 'news', 0, 1, 100, '', '', '', 5, 1, 3, 1, 'news', 6, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'news', '/news', '', '', '', '2024-07-31 11:51:09', '2024-07-31 16:53:47', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (6, '联系我们', 'contact', 0, 1, 100, '', '', '', 6, 1, 1, 2, 'contact', 20, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'contact', '/contact', '', '', '', '2024-07-31 11:51:35', '2024-07-31 15:52:35', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (7, '公司简介', 'company', 1, 1, 100, '', '', '', 1, 1, 1, 1, 'about', 20, '', 'cover', 'lists', 'view', 1, '', 2, 1, 'company', '/about-us/company', '', '', '', '2024-07-31 11:52:40', '2024-07-31 11:52:40', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (8, '企业架构', 'org', 1, 1, 100, '', '', '', 1, 1, 1, 1, 'about', 20, '', 'cover', 'lists', 'view', 1, '', 2, 1, 'org', '/about-us/org', '', '', '', '2024-07-31 11:53:05', '2024-07-31 11:53:05', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (9, '机械五金', 'Mechanical Hardware', 2, 1, 100, '', '', '', 2, 1, 3, 1, 'product', 9, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'Mechanical Hardware', '/product/mechanical-hardware', '', '', '', '2024-07-31 11:54:49', '2024-07-31 15:09:54', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (10, '建筑五金', 'building hardware', 2, 1, 100, '', '', '', 2, 1, 3, 1, 'product', 9, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'building hardware', '/product/building-hardware', '', '', '', '2024-07-31 11:55:14', '2024-07-31 15:10:00', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (11, '公司新闻', 'company', 5, 1, 100, '', '', '', 5, 1, 3, 1, 'news', 6, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'company', '/news/company', '', '', '', '2024-07-31 11:56:18', '2024-07-31 16:53:52', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (12, '行业新闻', 'industry', 5, 1, 100, '', '', '', 5, 1, 3, 1, 'news', 6, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'industry', '/news/industry', '', '', '', '2024-07-31 11:56:47', '2024-07-31 16:53:56', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (13, '客户案例分类', 'case class', 3, 1, 100, '', '', '', 3, 1, 3, 1, 'case', 9, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'case class', '/case/case-class', '', '', '', '2024-07-31 15:40:43', '2024-07-31 15:40:56', '', '');
INSERT INTO `wjjd_category` (`id`, `title`, `title_en`, `pid`, `status`, `sort`, `meta_title`, `meta_keyword`, `meta_description`, `module_id`, `is_delete`, `type`, `is_redirect_child`, `remark`, `page`, `go_url`, `default_tpl`, `list_tpl`, `view_tpl`, `target`, `image`, `is_relation`, `relation_attribute_count`, `seo_url`, `uri`, `introduce_content`, `introduce_video_url`, `introduce_image`, `created_at`, `updated_at`, `note`, `note_image`) VALUES (14, '联系我们', 'contact us', 6, 1, 100, '', '', '', 6, 1, 1, 1, 'contact', 10, '', 'cover', 'lists', 'view', 1, '', 0, 1, 'address', '/contact/address', '', '', '', '2024-07-31 15:52:51', '2024-07-31 16:53:15', '', '');
COMMIT;

-- ----------------------------
-- Table structure for cn_config
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_config`;
CREATE TABLE `wjjd_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL DEFAULT '' COMMENT '名称',
  `config_group` varchar(255) NOT NULL DEFAULT '' COMMENT '配置分组',
  `config_code` varchar(45) NOT NULL DEFAULT '' COMMENT '标识',
  `config_value` varchar(1000) NOT NULL DEFAULT '' COMMENT '值',
  `field_option` varchar(1000) NOT NULL DEFAULT '' COMMENT '选项',
  `field_type` varchar(45) NOT NULL DEFAULT '' COMMENT '字段类型',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1启用 2禁用',
  `sort` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '排序',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `unique_code` (`config_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COMMENT='站点配置';

-- ----------------------------
-- Records of cn_config
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (1, '标题', 'base', 'title', '站点名称', ' ', 'input', 1, 2, 1, '2024-06-12 18:06:54', '2024-07-03 21:16:07');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (2, '站点描述', 'base', 'meta_description', '站点描述', '', 'textarea', 1, 3, 1, '2020-12-05 23:26:56', '2024-04-23 15:51:52');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (3, '站点关键词', 'base', 'meta_keyword', '站点关键词', '', 'textarea', 1, 4, 1, NULL, '2024-04-23 15:51:52');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (4, '邮箱', 'base', 'email', '投诉邮箱：<a href=\'mailto:test@email.com\'>test@email.com</a>', '', 'input', 1, 5, 1, NULL, '2024-04-23 15:51:52');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (5, '联系地址', 'base', 'address', '联系导致', '', 'textarea', 1, 7, 1, NULL, '2024-04-23 15:51:52');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (6, '联系电话', 'base', 'tel', '总机：<a href=\'tel:0755-88888888\'>0755-88888888</a>', '', 'input', 1, 6, 1, '2021-05-28 20:45:33', '2024-04-23 15:51:52');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (7, '备案信息', 'base', 'icp', '版权所有：站点名称\n备案号：皖ICP备xxxxxx号\n皖公网安备 xxxxxxxxxx号', '', 'textarea', 1, 8, 1, '2021-05-28 20:57:24', '2024-04-23 15:51:52');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (8, '服务地址', 'email', 'smtp_host', '', '', 'input', 1, 1, 1, '2021-06-19 15:57:22', '2024-06-11 22:21:51');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (9, '服务端口', 'email', 'smtp_port', '', '', 'input', 1, 2, 1, '2021-06-19 21:25:57', '2024-04-23 15:51:53');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (10, '服务账号', 'email', 'smtp_user', '', '', 'input', 1, 3, 1, '2021-06-19 21:26:41', '2024-06-11 22:21:03');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (11, '服务密码', 'email', 'smtp_password', '', '', 'input', 1, 4, 1, '2021-06-19 21:27:01', '2024-04-23 15:51:53');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (12, '站点logo', 'base', 'logo', 'upload/wjjd_cn/20240731/20240731141432521.jpg', '', 'image', 1, 1, 1, '2021-06-20 18:13:52', '2024-06-12 18:10:36');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (13, '手机二维码', 'base', 'qrcode', 'upload/wjjd_cn/20240731/20240731171451152.jpg', '', 'image', 1, 10, 1, '2021-09-21 16:26:00', '2024-07-31 17:20:53');
INSERT INTO `wjjd_config` (`id`, `name`, `config_group`, `config_code`, `config_value`, `field_option`, `field_type`, `status`, `sort`, `is_delete`, `created_at`, `updated_at`) VALUES (15, '底部公众号', 'base', 'wmp_account', 'upload/wjjd_cn/20240731/20240731172130598.jpg', '', 'image', 1, 100, 1, '2024-07-31 17:20:26', '2024-07-31 17:20:26');
COMMIT;

-- ----------------------------
-- Table structure for cn_feedback_field
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_feedback_field`;
CREATE TABLE `wjjd_feedback_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `form_id` int(11) NOT NULL DEFAULT '0' COMMENT '关联外键',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '字段名称',
  `code` varchar(45) NOT NULL DEFAULT '' COMMENT '字段code',
  `field_type` varchar(45) NOT NULL DEFAULT '' COMMENT '字段类型',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '字段状态 1启用 2禁用',
  `show_list` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '显示在列表 1显示 2隐藏',
  `is_require` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '必填,1不是必填,2必填',
  `is_system` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1 系统 2自定义',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1未删除 2已删除',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `unique_form_id_code` (`form_id`,`code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义表单字段';

-- ----------------------------
-- Records of cn_feedback_field
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_feedback_form
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_feedback_form`;
CREATE TABLE `wjjd_feedback_form` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '表单名称',
  `form_code` varchar(45) NOT NULL DEFAULT '' COMMENT '表单code',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '表单状态1启用 2禁用',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `unique_code` (`form_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义表单';

-- ----------------------------
-- Records of cn_feedback_form
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cn_field
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_field`;
CREATE TABLE `wjjd_field` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module_id` int(10) unsigned NOT NULL,
  `name` varchar(45) NOT NULL DEFAULT '' COMMENT '名称',
  `code` varchar(45) NOT NULL DEFAULT '' COMMENT '标识',
  `field_type` varchar(45) NOT NULL DEFAULT '' COMMENT '类型，1 varchar文本 2 editor富文本 3 radio单选 4 mutiple复选 5 file文件上传',
  `field_option` varchar(500) NOT NULL DEFAULT '' COMMENT '选择项',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1启用 2禁用',
  `show_list` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '显示在列表,1不显示 2显示',
  `is_require` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '必填,1不是必填,2必填',
  `is_system` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1 系统 2自定义',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `unique_module_id_code` (`module_id`,`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COMMENT='字段';

-- ----------------------------
-- Records of cn_field
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (1, 1, '标题', 'title', 'input', '', 1, 1, 1, 1, 1, 1, '2024-07-31 11:46:36', '2024-07-31 11:46:36');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (2, 1, 'seo标题', 'meta_title', 'textarea', '', 2, 1, 2, 2, 1, 1, '2024-07-31 11:46:36', '2024-07-31 11:46:36');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (3, 1, 'seo描述', 'meta_description', 'textarea', '', 3, 1, 2, 2, 1, 1, '2024-07-31 11:46:36', '2024-07-31 11:46:36');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (4, 1, 'seo关键词', 'meta_keyword', 'textarea', '', 4, 1, 2, 2, 1, 1, '2024-07-31 11:46:36', '2024-07-31 11:46:36');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (5, 1, '状态', 'status', 'radio', '', 5, 1, 2, 1, 1, 1, '2024-07-31 11:46:36', '2024-07-31 11:46:36');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (6, 1, '排序', 'sort', 'input', '', 6, 1, 2, 2, 1, 1, '2024-07-31 11:46:36', '2024-07-31 11:46:36');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (7, 1, '图片', 'image', 'image', '', 7, 1, 1, 2, 1, 1, '2024-07-31 11:46:36', '2024-07-31 11:46:36');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (8, 1, '访问次数', 'hit', 'input', '', 8, 1, 1, 2, 1, 1, '2024-07-31 11:46:36', '2024-07-31 11:46:36');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (9, 1, '创建时间', 'created_at', 'datetime', '', 9, 1, 1, 2, 1, 1, '2024-07-31 11:46:36', '2024-07-31 11:46:36');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (10, 1, '内容', 'content', 'editor', '', 10, 1, 2, 2, 2, 1, '2024-07-31 11:46:36', '2024-07-31 11:46:36');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (11, 2, '标题', 'title', 'input', '', 1, 1, 1, 1, 1, 1, '2024-07-31 11:46:55', '2024-07-31 11:46:55');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (12, 2, 'seo标题', 'meta_title', 'textarea', '', 2, 1, 2, 2, 1, 1, '2024-07-31 11:46:55', '2024-07-31 11:46:55');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (13, 2, 'seo描述', 'meta_description', 'textarea', '', 3, 1, 2, 2, 1, 1, '2024-07-31 11:46:55', '2024-07-31 11:46:55');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (14, 2, 'seo关键词', 'meta_keyword', 'textarea', '', 4, 1, 2, 2, 1, 1, '2024-07-31 11:46:55', '2024-07-31 11:46:55');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (15, 2, '状态', 'status', 'radio', '', 5, 1, 2, 1, 1, 1, '2024-07-31 11:46:55', '2024-07-31 11:46:55');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (16, 2, '排序', 'sort', 'input', '', 6, 1, 2, 2, 1, 1, '2024-07-31 11:46:55', '2024-07-31 11:46:55');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (17, 2, '图片', 'image', 'image', '', 7, 1, 1, 2, 1, 1, '2024-07-31 11:46:55', '2024-07-31 11:46:55');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (18, 2, '访问次数', 'hit', 'input', '', 8, 1, 1, 2, 1, 1, '2024-07-31 11:46:55', '2024-07-31 11:46:55');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (19, 2, '创建时间', 'created_at', 'datetime', '', 9, 1, 1, 2, 1, 1, '2024-07-31 11:46:55', '2024-07-31 11:46:55');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (20, 2, '内容', 'content', 'editor', '', 10, 1, 2, 2, 2, 1, '2024-07-31 11:46:55', '2024-07-31 11:46:55');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (21, 3, '标题', 'title', 'input', '', 1, 1, 1, 1, 1, 1, '2024-07-31 11:47:28', '2024-07-31 11:47:28');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (22, 3, 'seo标题', 'meta_title', 'textarea', '', 2, 1, 2, 2, 1, 1, '2024-07-31 11:47:28', '2024-07-31 11:47:28');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (23, 3, 'seo描述', 'meta_description', 'textarea', '', 3, 1, 2, 2, 1, 1, '2024-07-31 11:47:28', '2024-07-31 11:47:28');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (24, 3, 'seo关键词', 'meta_keyword', 'textarea', '', 4, 1, 2, 2, 1, 1, '2024-07-31 11:47:28', '2024-07-31 11:47:28');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (25, 3, '状态', 'status', 'radio', '', 5, 1, 2, 1, 1, 1, '2024-07-31 11:47:28', '2024-07-31 11:47:28');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (26, 3, '排序', 'sort', 'input', '', 6, 1, 2, 2, 1, 1, '2024-07-31 11:47:28', '2024-07-31 11:47:28');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (27, 3, '图片', 'image', 'image', '', 7, 1, 1, 2, 1, 1, '2024-07-31 11:47:28', '2024-07-31 11:47:28');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (28, 3, '访问次数', 'hit', 'input', '', 8, 1, 1, 2, 1, 1, '2024-07-31 11:47:28', '2024-07-31 11:47:28');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (29, 3, '创建时间', 'created_at', 'datetime', '', 9, 1, 1, 2, 1, 1, '2024-07-31 11:47:28', '2024-07-31 11:47:28');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (30, 3, '内容', 'content', 'editor', '', 10, 1, 2, 2, 2, 1, '2024-07-31 11:47:28', '2024-07-31 11:47:28');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (31, 4, '标题', 'title', 'input', '', 1, 1, 1, 1, 1, 1, '2024-07-31 11:48:05', '2024-07-31 11:48:05');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (32, 4, 'seo标题', 'meta_title', 'textarea', '', 2, 1, 2, 2, 1, 1, '2024-07-31 11:48:05', '2024-07-31 11:48:05');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (33, 4, 'seo描述', 'meta_description', 'textarea', '', 3, 1, 2, 2, 1, 1, '2024-07-31 11:48:05', '2024-07-31 11:48:05');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (34, 4, 'seo关键词', 'meta_keyword', 'textarea', '', 4, 1, 2, 2, 1, 1, '2024-07-31 11:48:05', '2024-07-31 11:48:05');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (35, 4, '状态', 'status', 'radio', '', 5, 1, 2, 1, 1, 1, '2024-07-31 11:48:05', '2024-07-31 11:48:05');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (36, 4, '排序', 'sort', 'input', '', 6, 1, 2, 2, 1, 1, '2024-07-31 11:48:05', '2024-07-31 11:48:05');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (37, 4, '图片', 'image', 'image', '', 7, 1, 1, 2, 1, 1, '2024-07-31 11:48:05', '2024-07-31 11:48:05');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (38, 4, '访问次数', 'hit', 'input', '', 8, 1, 1, 2, 1, 1, '2024-07-31 11:48:05', '2024-07-31 11:48:05');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (39, 4, '创建时间', 'created_at', 'datetime', '', 9, 1, 1, 2, 1, 1, '2024-07-31 11:48:05', '2024-07-31 11:48:05');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (40, 4, '内容', 'content', 'editor', '', 10, 1, 2, 2, 2, 1, '2024-07-31 11:48:05', '2024-07-31 11:48:05');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (41, 5, '标题', 'title', 'input', '', 1, 1, 1, 1, 1, 1, '2024-07-31 11:48:24', '2024-07-31 11:48:24');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (42, 5, 'seo标题', 'meta_title', 'textarea', '', 2, 1, 2, 2, 1, 1, '2024-07-31 11:48:24', '2024-07-31 11:48:24');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (43, 5, 'seo描述', 'meta_description', 'textarea', '', 3, 1, 2, 2, 1, 1, '2024-07-31 11:48:24', '2024-07-31 11:48:24');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (44, 5, 'seo关键词', 'meta_keyword', 'textarea', '', 4, 1, 2, 2, 1, 1, '2024-07-31 11:48:24', '2024-07-31 11:48:24');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (45, 5, '状态', 'status', 'radio', '', 5, 1, 2, 1, 1, 1, '2024-07-31 11:48:24', '2024-07-31 11:48:24');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (46, 5, '排序', 'sort', 'input', '', 6, 1, 2, 2, 1, 1, '2024-07-31 11:48:24', '2024-07-31 11:48:24');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (47, 5, '图片', 'image', 'image', '', 7, 1, 1, 2, 1, 1, '2024-07-31 11:48:24', '2024-07-31 11:48:24');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (48, 5, '访问次数', 'hit', 'input', '', 8, 1, 1, 2, 1, 1, '2024-07-31 11:48:24', '2024-07-31 11:48:24');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (49, 5, '创建时间', 'created_at', 'datetime', '', 9, 1, 1, 2, 1, 1, '2024-07-31 11:48:24', '2024-07-31 11:48:24');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (50, 5, '内容', 'content', 'editor', '', 10, 1, 2, 2, 2, 1, '2024-07-31 11:48:24', '2024-07-31 11:48:24');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (51, 6, '标题', 'title', 'input', '', 1, 1, 1, 1, 1, 1, '2024-07-31 11:48:52', '2024-07-31 11:48:52');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (52, 6, 'seo标题', 'meta_title', 'textarea', '', 2, 1, 2, 2, 1, 1, '2024-07-31 11:48:52', '2024-07-31 11:48:52');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (53, 6, 'seo描述', 'meta_description', 'textarea', '', 3, 1, 2, 2, 1, 1, '2024-07-31 11:48:52', '2024-07-31 11:48:52');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (54, 6, 'seo关键词', 'meta_keyword', 'textarea', '', 4, 1, 2, 2, 1, 1, '2024-07-31 11:48:52', '2024-07-31 11:48:52');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (55, 6, '状态', 'status', 'radio', '', 5, 1, 2, 1, 1, 1, '2024-07-31 11:48:52', '2024-07-31 11:48:52');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (56, 6, '排序', 'sort', 'input', '', 6, 1, 2, 2, 1, 1, '2024-07-31 11:48:52', '2024-07-31 11:48:52');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (57, 6, '图片', 'image', 'image', '', 7, 1, 1, 2, 1, 1, '2024-07-31 11:48:52', '2024-07-31 11:48:52');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (58, 6, '访问次数', 'hit', 'input', '', 8, 1, 1, 2, 1, 1, '2024-07-31 11:48:52', '2024-07-31 11:48:52');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (59, 6, '创建时间', 'created_at', 'datetime', '', 9, 1, 1, 2, 1, 1, '2024-07-31 11:48:52', '2024-07-31 11:48:52');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (60, 6, '内容', 'content', 'editor', '', 10, 1, 2, 2, 2, 1, '2024-07-31 11:48:52', '2024-07-31 11:48:52');
INSERT INTO `wjjd_field` (`id`, `module_id`, `name`, `code`, `field_type`, `field_option`, `sort`, `status`, `show_list`, `is_require`, `is_system`, `is_delete`, `created_at`, `updated_at`) VALUES (61, 5, '列表页描述', 'list_desc', 'textarea', '', 9, 1, 1, 2, 2, 1, '2024-07-31 15:34:20', '2024-07-31 15:37:26');
COMMIT;

-- ----------------------------
-- Table structure for cn_flag
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_flag`;
CREATE TABLE `wjjd_flag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
  `code` varchar(100) NOT NULL DEFAULT '' COMMENT '唯一标识',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态，1启用，2 禁用',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1未删除 2已删除',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uinque_code` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='文档标识';

-- ----------------------------
-- Records of cn_flag
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_flag` (`id`, `name`, `code`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (1, '推荐', 'recommend', 1, 1, '2021-10-11 14:46:30', '2024-06-30 19:51:59');
INSERT INTO `wjjd_flag` (`id`, `name`, `code`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (2, '热门', 'hot', 1, 1, '2021-10-11 14:46:51', '2024-07-31 17:01:02');
INSERT INTO `wjjd_flag` (`id`, `name`, `code`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (3, '图文', 'picture', 1, 1, '2021-10-11 14:47:01', '2021-10-11 14:48:15');
COMMIT;

-- ----------------------------
-- Table structure for cn_module
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_module`;
CREATE TABLE `wjjd_module` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL DEFAULT '' COMMENT '名称',
  `code` varchar(45) NOT NULL DEFAULT '' COMMENT '标识',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1启用 2禁用',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1 未删除 2 已删除',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `unique_code` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='模型';

-- ----------------------------
-- Records of cn_module
-- ----------------------------
BEGIN;
INSERT INTO `wjjd_module` (`id`, `name`, `code`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (1, '关于我们', 'about', 1, 1, '2024-07-31 11:46:37', '2024-07-31 11:46:37');
INSERT INTO `wjjd_module` (`id`, `name`, `code`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (2, '产品中心', 'product', 1, 1, '2024-07-31 11:46:55', '2024-07-31 11:46:55');
INSERT INTO `wjjd_module` (`id`, `name`, `code`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (3, '客户案例', 'case', 1, 1, '2024-07-31 11:47:29', '2024-07-31 11:47:29');
INSERT INTO `wjjd_module` (`id`, `name`, `code`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (4, '合作伙伴', 'partner', 1, 1, '2024-07-31 11:48:06', '2024-07-31 11:48:06');
INSERT INTO `wjjd_module` (`id`, `name`, `code`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (5, '新闻资讯', 'news', 1, 1, '2024-07-31 11:48:24', '2024-07-31 11:48:24');
INSERT INTO `wjjd_module` (`id`, `name`, `code`, `status`, `is_delete`, `created_at`, `updated_at`) VALUES (6, '联系我们', 'contact', 1, 1, '2024-07-31 11:48:53', '2024-07-31 11:48:53');
COMMIT;

-- ----------------------------
-- Table structure for cn_relation_attribute_category
-- ----------------------------
DROP TABLE IF EXISTS `wjjd_relation_attribute_category`;
CREATE TABLE `wjjd_relation_attribute_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属性ID',
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `is_delete` tinyint(4) NOT NULL DEFAULT '1' COMMENT '删除状态',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `key_attribute_id_category_id` (`attribute_id`,`category_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='属性和栏目关系';

-- ----------------------------
-- Records of cn_relation_attribute_category
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
